﻿<?xml version="1.0" encoding="utf-8" ?>
<DbDataRequest connection="$UserLoginDBConnection$" type="$UserLoginDbType$" defaultFormatter="bizobj User(groups)">
  <SqlStatement hasResults="true">
    SELECT u.id,u.userName,u.password,u.firstName,u.lastName,u.companyId,u.email,u.enable,l.groupId as groupsid
    FROM Users u LEFT JOIN UserGroupLink l ON u.id = l.userId WHERE u.companyId=@companyId
  </SqlStatement>
  <Param name="companyId" type="UniqueIdentifier"/>
  
</DbDataRequest>